﻿using System;
using System.Collections.Generic;
using System.Text;

namespace ScriptsGenerator.Helper
{
    public static class SqlScriptsConstant
    {
        public const string ALERT_TABLE_DROP_COLUMN = @"ALTER TABLE {0} DROP COLUMN {1};";
        public const string ALERT_TABLE_DROP_PKEY_CONSTRIANTS = @"ALTER TABLE {0} DROP CONSTRAINT PK_{1};";
        public const string ALTER_TABLE_ADD_COLUMN = @"ALTER TABLE {0} ADD {1};";
        public const string ALTER_TABLE_ALTER_COLUMN = @"ALTER TABLE {0} ALTER COLUMN {1};";

        public const string DROP_TABLE = "DROPT TABLE {0};";
        public const string EXEC_SP_DROPDEFAULT = "EXEC SP_DROPDEFAULT '{0}','{1}';";
    }
}
